This forum is closed to new posts and
responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:
Below, is the resolution to our issue ... for others who find themselves in the same boat as you upgrade to 8.5.x:
The problem stems from the upgrade to the 64-bit version of Domino and Windows. Since your script had been using ODBC2, that indicates that you were previously using our Lotus ODBC drivers, which utilize nodbc2.dcx.
However, now that you are on 64-bit Domino and 64-bit Windows, this attempted connection is failing for two reasons:
1. According to the driver version you provided, you are now using the SQL Native Client, rather than the ODBC drivers. (Certainly this is understandable, since the ODBC drivers are 32-bit only until 8.5.2 is released). However, the SQL Native Client cannot and will not use ODBC2. It is only capable of utilizing an OLE DB connection to MS SQL.
2. Domino 64-bit cannot use ODBC connections at this time. That functionality will be added to the 64-bit code in 8.5.2. (That is to say, even if we had an ODBC driver in a 64-bit version, we would not be able to use ODBC2 until 8.5.2).
I'm assuming that you have a 64-bit version of the SQL Native Client. If so, then you're on the right track - we just need to change your script to use the correct connector type. You will first want to create an OLE DB connection to your MS SQL database (being a Microsoft connector, I can't provide explicit instructions, but they should be generally available online). Then, simply create an LCConnection of type "OLEDB" in your
script, which utilizes that connection. For your reference, here are the LCConnection parameters for OLE DB:
connection.Provider = "sqloledb" if connecting to SQL Server
connection.Init_datasource = Name of your SQL Server
connection.Database = Name of your database
connection.UserId = Userid
connection.Password = Password
connection.CommitFrequency = Commit every "N" operations
connection.Metadata = Table/View/Proc that you are connecting to.
Now, 64-bit Domino will only be able to use a 64-bit connector, so if you do in fact have a 32-bit version of the SQL Native Client, you will need to download and install the 64-bit version.
Feedback response number WEBB83SQQ7 created by ~Laura Dwohipikonyoni on 03/22/2010
Resolution ...
Return to top
. . Resolution ... (~Laura Dwohipik... 22.Mar.10) 
